Capital Area SQL Server User Group

Greetings, data enthusiasts!

Our November meeting is scheduled for Monday, November 10th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

Please RSVP here if you are attending, so we can purchase an appropriate amount of food for everyone. Food will be Korean street food from K-Plate. For this meeting, we are welcoming Ken Schwartz, a longtime member of our user group going way, way back to the early days! 15+ years with us and he is STILL here and sharing his knowledge. Thanks, Ken!

Our meeting schedule is as follows:

• 5:30 PM: Food, soft drinks, and networking
• 6:15 PM: Chapter news and announcements
• 6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Ken will be presenting: An Introduction to Query Store by Someone Who is no Expert on Query Store:
Consider this a brief overview of Query Store:
What is it?
How to enable it?
A couple of important settings
Built in reporting
Forcing Plans

Greetings, data enthusiasts!

Our January meeting is scheduled for Monday, January 12th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

Please RSVP if you are attending, so we can purchase an appropriate amount of food for everyone. Food will be kebabs and (maybe?) pizza from Legends Pizza/Kebab in Colonie. If you have a request, feel free to message me with what you're interested in having. For this meeting, we are welcoming Pallavi Varandani, who is joining us from New York City! Thank you for taking the time and energy to join us and share your knowledge!

Our meeting schedule is as follows:

5:30 PM: Food, soft drinks, and networking
6:15 PM: Chapter news and announcements
6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM. Pallavi will be presenting on a topic that tied closely with data integrity & quality: "Data Constraints 101: The Guardians of Your Database".

Session Details:
What if you could ensure the accuracy and integrity of your data effortlessly? Join this sessions on Data Constraints in databases, where we'll uncover the fundamental rules that keep your data reliable and consistent. Starting with the basics, we'll explore what data constraints are and why they are essential for maintaining the quality of your database.

We'll dive into different types of data constraints, including primary keys, foreign keys, unique constraints, and check constraints, explaining how each one helps in enforcing data rules and relationships within your database. You'll learn the correct syntax for defining these constraints and see practical examples of how they can prevent errors and ensure data integrity.

Through real-world scenarios, we'll illustrate how data constraints can be used to enforce business rules and improve the overall robustness of your database applications. We'll also discuss the performance implications of using constraints and best practices for their implementation to optimize both efficiency and accuracy.

Finally, we'll cover common challenges and pitfalls associated with data constraints, providing tips on how to avoid them and ensure your database remains a reliable asset for your organization. Whether you're a novice or looking to deepen your understanding, this session will equip you with the knowledge to leverage data constraints effectively and enhance the reliability of your database systems.

Greetings, data enthusiasts!

Our February meeting is scheduled for Monday, February 9th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

Please RSVP if you are attending, so we can purchase an appropriate amount of food for everyone. Food is TBA and will be announced closer to the meeting date. For this meeting, we will welcome back Dominick Raimato, who is joining us from the exotic land of New Jersey! Thank you for taking the time and energy to join us and share your knowledge!

Our meeting schedule is as follows:

5:30 PM: Food, soft drinks, and networking
6:15 PM: Chapter news and announcements
6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM. Dominick will be presenting on a fun hands-on topic that tracks data round-trip from creation to insights: "Hey Real-Time Intelligence - should I go outside today?". Even if you are not using these apps, the process is extensible to other platforms!

Session Details:
I love it when people tell me they need real time data. More times than not, this is not really true. However, many of us work with processes and systems that could truly benefit from the value of having data being shared in real time. Enter Real-Time Intelligence – the solution that will help you harness the value of the real time data being produced within your organization and make it actionable!

If you have people pestering you for data that must be received in real time, then this session is for you! We will walk through the basics of building out a weather prediction solution that leverages the Real-Time Intelligence solution within Microsoft Fabric. We will go through the process to collect weather data on a Raspberry Pi, send it to Fabric via Azure IoT Hub, and connect to the data in Microsoft Fabric. From there, we will transform, predict, and alert you on whether or not you should go outside for today! While sample connectors are cool, it will be fun to see us manipulate our sensors in the room and see predictions in real time!

At the end of this session, you will feel comfortable with understanding the end-to-end process of integrating your IoT connected devices into Fabric’s Real-Time Intelligence hub, see a prediction, and take an action as a result!